<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--NewPage-->
<HTML>
<HEAD>
<TITLE>
HSSFCellStyle (POI API Documentation)
</TITLE>

<META NAME="keywords" CONTENT="org.apache.poi.hssf.usermodel.HSSFCellStyle class">

<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../../stylesheet.css" TITLE="Style">

<SCRIPT type="text/javascript">
function windowTitle()
{
    parent.document.title="HSSFCellStyle (POI API Documentation)";
}
</SCRIPT>
<NOSCRIPT>
</NOSCRIPT>

</HEAD>

<BODY BGCOLOR="white" onload="windowTitle();">


<!-- ========= START OF TOP NAVBAR ======= -->
<A NAME="navbar_top"><!-- --></A>
<A HREF="#skip-navbar_top" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_top_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
  <TR ALIGN="center" VALIGN="top">
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="class-use/HSSFCellStyle.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html" title="class in org.apache.poi.hssf.usermodel"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFChart.html" title="class in org.apache.poi.hssf.usermodel"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../../index.html?org/apache/poi/hssf/usermodel/HSSFCellStyle.html" target="_top"><B>FRAMES</B></A>  &nbsp;
&nbsp;<A HREF="HSSFCellStyle.html" target="_top"><B>NO FRAMES</B></A>  &nbsp;
&nbsp;<SCRIPT type="text/javascript">
  <!--
  if(window==top) {
    document.writeln('<A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>');
  }
  //-->
</SCRIPT>
<NOSCRIPT>
  <A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>


</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
  SUMMARY:&nbsp;NESTED&nbsp;|&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_summary">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL:&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_detail">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_top"></A>
<!-- ========= END OF TOP NAVBAR ========= -->

<HR>
<!-- ======== START OF CLASS DATA ======== -->
<H2>
<FONT SIZE="-1">
org.apache.poi.hssf.usermodel</FONT>
<BR>
Class HSSFCellStyle</H2>
<PRE>
java.lang.Object
  <IMG SRC="../../../../../resources/inherit.gif" ALT="extended by "><B>org.apache.poi.hssf.usermodel.HSSFCellStyle</B>
</PRE>
<DL>
<DT><B>All Implemented Interfaces:</B> <DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></DD>
</DL>
<HR>
<DL>
<DT><PRE>public final class <B>HSSFCellStyle</B><DT>extends java.lang.Object<DT>implements <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></DL>
</PRE>

<P>
High level representation of the style of a cell in a sheet of a workbook.
<P>

<P>
<DL>
<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#createCellStyle()"><CODE>HSSFWorkbook.createCellStyle()</CODE></A>, 
<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#getCellStyleAt(short)"><CODE>HSSFWorkbook.getCellStyleAt(short)</CODE></A>, 
<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html#setCellStyle(org.apache.poi.hssf.usermodel.HSSFCellStyle)"><CODE>HSSFCell.setCellStyle(HSSFCellStyle)</CODE></A></DL>
<HR>

<P>
<!-- =========== FIELD SUMMARY =========== -->

<A NAME="field_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>Field Summary</B></FONT></TH>
</TR>
</TABLE>
&nbsp;<A NAME="fields_inherited_from_class_org.apache.poi.ss.usermodel.CellStyle"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>Fields inherited from interface org.apache.poi.ss.usermodel.<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER">ALIGN_CENTER</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER_SELECTION">ALIGN_CENTER_SELECTION</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_FILL">ALIGN_FILL</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_GENERAL">ALIGN_GENERAL</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_JUSTIFY">ALIGN_JUSTIFY</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_LEFT">ALIGN_LEFT</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_RIGHT">ALIGN_RIGHT</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALT_BARS">ALT_BARS</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BIG_SPOTS">BIG_SPOTS</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT">BORDER_DASH_DOT</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT">BORDER_DASH_DOT_DOT</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED">BORDER_DASHED</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED">BORDER_DOTTED</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE">BORDER_DOUBLE</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR">BORDER_HAIR</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM">BORDER_MEDIUM</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT">BORDER_MEDIUM_DASH_DOT</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT">BORDER_MEDIUM_DASH_DOT_DOT</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED">BORDER_MEDIUM_DASHED</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE">BORDER_NONE</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT">BORDER_SLANTED_DASH_DOT</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK">BORDER_THICK</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN">BORDER_THIN</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BRICKS">BRICKS</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#DIAMONDS">DIAMONDS</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#FINE_DOTS">FINE_DOTS</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#LEAST_DOTS">LEAST_DOTS</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#LESS_DOTS">LESS_DOTS</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#NO_FILL">NO_FILL</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SOLID_FOREGROUND">SOLID_FOREGROUND</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SPARSE_DOTS">SPARSE_DOTS</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SQUARES">SQUARES</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_BACKWARD_DIAG">THICK_BACKWARD_DIAG</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_FORWARD_DIAG">THICK_FORWARD_DIAG</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_HORZ_BANDS">THICK_HORZ_BANDS</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_VERT_BANDS">THICK_VERT_BANDS</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_BACKWARD_DIAG">THIN_BACKWARD_DIAG</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_FORWARD_DIAG">THIN_FORWARD_DIAG</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_HORZ_BANDS">THIN_HORZ_BANDS</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_VERT_BANDS">THIN_VERT_BANDS</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_BOTTOM">VERTICAL_BOTTOM</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_CENTER">VERTICAL_CENTER</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_JUSTIFY">VERTICAL_JUSTIFY</A>, <A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_TOP">VERTICAL_TOP</A></CODE></TD>
</TR>
</TABLE>
&nbsp;
<!-- ======== CONSTRUCTOR SUMMARY ======== -->

<A NAME="constructor_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>Constructor Summary</B></FONT></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected </CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#HSSFCellStyle(short, org.apache.poi.hssf.record.ExtendedFormatRecord, org.apache.poi.hssf.usermodel.HSSFWorkbook)">HSSFCellStyle</A></B>(short&nbsp;index,
              <A HREF="../../../../../org/apache/poi/hssf/record/ExtendedFormatRecord.html" title="class in org.apache.poi.hssf.record">ExtendedFormatRecord</A>&nbsp;rec,
              <A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</A>&nbsp;workbook)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Creates new HSSFCellStyle why would you want to do this??</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected </CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#HSSFCellStyle(short, org.apache.poi.hssf.record.ExtendedFormatRecord, org.apache.poi.hssf.model.InternalWorkbook)">HSSFCellStyle</A></B>(short&nbsp;index,
              <A HREF="../../../../../org/apache/poi/hssf/record/ExtendedFormatRecord.html" title="class in org.apache.poi.hssf.record">ExtendedFormatRecord</A>&nbsp;rec,
              <A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html" title="class in org.apache.poi.hssf.model">InternalWorkbook</A>&nbsp;workbook)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
</TABLE>
&nbsp;
<!-- ========== METHOD SUMMARY =========== -->

<A NAME="method_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>Method Summary</B></FONT></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#cloneStyleFrom(org.apache.poi.ss.usermodel.CellStyle)">cloneStyleFrom</A></B>(<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A>&nbsp;source)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Clones all the style information from another
  HSSFCellStyle, onto this one.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#cloneStyleFrom(org.apache.poi.hssf.usermodel.HSSFCellStyle)">cloneStyleFrom</A></B>(<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html" title="class in org.apache.poi.hssf.usermodel">HSSFCellStyle</A>&nbsp;source)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#equals(java.lang.Object)">equals</A></B>(java.lang.Object&nbsp;obj)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getAlignment()">getAlignment</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the type of horizontal alignment for the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getBorderBottom()">getBorderBottom</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the type of border to use for the bottom border of the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getBorderLeft()">getBorderLeft</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the type of border to use for the left border of the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getBorderRight()">getBorderRight</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the type of border to use for the right border of the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getBorderTop()">getBorderTop</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the type of border to use for the top border of the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getBottomBorderColor()">getBottomBorderColor</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the color to use for the left border</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getDataFormat()">getDataFormat</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the index of the format</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getDataFormatString()">getDataFormatString</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get the format string</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getDataFormatString(org.apache.poi.hssf.model.InternalWorkbook)">getDataFormatString</A></B>(<A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html" title="class in org.apache.poi.hssf.model">InternalWorkbook</A>&nbsp;workbook)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get the contents of the format string, by looking up
  the DataFormat against the supplied low level workbook</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getDataFormatString(org.apache.poi.ss.usermodel.Workbook)">getDataFormatString</A></B>(<A HREF="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</A>&nbsp;workbook)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get the contents of the format string, by looking up
  the DataFormat against the supplied workbook</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getFillBackgroundColor()">getFillBackgroundColor</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get the background fill color.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/util/HSSFColor.html" title="class in org.apache.poi.hssf.util">HSSFColor</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getFillBackgroundColorColor()">getFillBackgroundColorColor</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Gets the color object representing the current
  background fill, resolving indexes using
  the supplied workbook.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getFillForegroundColor()">getFillForegroundColor</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get the foreground fill color.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/util/HSSFColor.html" title="class in org.apache.poi.hssf.util">HSSFColor</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getFillForegroundColorColor()">getFillForegroundColorColor</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Gets the color object representing the current
  foreground fill, resolving indexes using
  the supplied workbook.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getFillPattern()">getFillPattern</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the fill pattern (??) - set to 1 to fill with foreground color</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFFont.html" title="class in org.apache.poi.hssf.usermodel">HSSFFont</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getFont(org.apache.poi.ss.usermodel.Workbook)">getFont</A></B>(<A HREF="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</A>&nbsp;parentWorkbook)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;gets the font for this style</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getFontIndex()">getFontIndex</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;gets the index of the font for this style</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getHidden()">getHidden</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get whether the cell's using this style are to be hidden</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getIndention()">getIndention</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the number of spaces to indent the text in the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getIndex()">getIndex</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the index within the HSSFWorkbook (sequence within the collection of ExtnededFormat objects)</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getLeftBorderColor()">getLeftBorderColor</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the color to use for the left border</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getLocked()">getLocked</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get whether the cell's using this style are to be locked</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html" title="class in org.apache.poi.hssf.usermodel">HSSFCellStyle</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getParentStyle()">getParentStyle</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Return the parent style for this cell style.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getRightBorderColor()">getRightBorderColor</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the color to use for the left border</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getRotation()">getRotation</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the degree of rotation for the text in the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getShrinkToFit()">getShrinkToFit</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Should the Cell be auto-sized by Excel to shrink
  it to fit if this text is too long?</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getTopBorderColor()">getTopBorderColor</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the color to use for the top border</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getUserStyleName()">getUserStyleName</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Gets the name of the user defined style.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;short</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getVerticalAlignment()">getVerticalAlignment</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get the type of vertical alignment for the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getWrapText()">getWrapText</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;get whether the text should be wrapped</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#hashCode()">hashCode</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setAlignment(short)">setAlignment</A></B>(short&nbsp;align)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the type of horizontal alignment for the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setBorderBottom(short)">setBorderBottom</A></B>(short&nbsp;border)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the type of border to use for the bottom border of the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setBorderLeft(short)">setBorderLeft</A></B>(short&nbsp;border)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the type of border to use for the left border of the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setBorderRight(short)">setBorderRight</A></B>(short&nbsp;border)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the type of border to use for the right border of the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setBorderTop(short)">setBorderTop</A></B>(short&nbsp;border)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the type of border to use for the top border of the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setBottomBorderColor(short)">setBottomBorderColor</A></B>(short&nbsp;color)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the color to use for the bottom border</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setDataFormat(short)">setDataFormat</A></B>(short&nbsp;fmt)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the data format (must be a valid format)</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setFillBackgroundColor(short)">setFillBackgroundColor</A></B>(short&nbsp;bg)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the background fill color.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setFillForegroundColor(short)">setFillForegroundColor</A></B>(short&nbsp;bg)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the foreground fill color
 <i>Note: Ensure Foreground color is set prior to background color.</i></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setFillPattern(short)">setFillPattern</A></B>(short&nbsp;fp)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;setting to one fills the cell with the foreground color...</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setFont(org.apache.poi.ss.usermodel.Font)">setFont</A></B>(<A HREF="../../../../../org/apache/poi/ss/usermodel/Font.html" title="interface in org.apache.poi.ss.usermodel">Font</A>&nbsp;font)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the font for this style</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setFont(org.apache.poi.hssf.usermodel.HSSFFont)">setFont</A></B>(<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFFont.html" title="class in org.apache.poi.hssf.usermodel">HSSFFont</A>&nbsp;font)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setHidden(boolean)">setHidden</A></B>(boolean&nbsp;hidden)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the cell's using this style to be hidden</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setIndention(short)">setIndention</A></B>(short&nbsp;indent)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the number of spaces to indent the text in the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setLeftBorderColor(short)">setLeftBorderColor</A></B>(short&nbsp;color)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the color to use for the left border</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setLocked(boolean)">setLocked</A></B>(boolean&nbsp;locked)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the cell's using this style to be locked</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setRightBorderColor(short)">setRightBorderColor</A></B>(short&nbsp;color)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the color to use for the right border</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setRotation(short)">setRotation</A></B>(short&nbsp;rotation)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the degree of rotation for the text in the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setShrinkToFit(boolean)">setShrinkToFit</A></B>(boolean&nbsp;shrinkToFit)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Controls if the Cell should be auto-sized
  to shrink to fit if the text is too long</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setTopBorderColor(short)">setTopBorderColor</A></B>(short&nbsp;color)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the color to use for the top border</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setUserStyleName(java.lang.String)">setUserStyleName</A></B>(java.lang.String&nbsp;styleName)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sets the name of the user defined style.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setVerticalAlignment(short)">setVerticalAlignment</A></B>(short&nbsp;align)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set the type of vertical alignment for the cell</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#setWrapText(boolean)">setWrapText</A></B>(boolean&nbsp;wrapped)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;set whether the text should be wrapped</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#verifyBelongsToWorkbook(org.apache.poi.hssf.usermodel.HSSFWorkbook)">verifyBelongsToWorkbook</A></B>(<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</A>&nbsp;wb)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Verifies that this style belongs to the supplied Workbook.</TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>Methods inherited from class java.lang.Object</B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE>clone, finalize, getClass, notify, notifyAll, toString, wait, wait, wait</CODE></TD>
</TR>
</TABLE>
&nbsp;
<P>

<!-- ========= CONSTRUCTOR DETAIL ======== -->

<A NAME="constructor_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>Constructor Detail</B></FONT></TH>
</TR>
</TABLE>

<A NAME="HSSFCellStyle(short, org.apache.poi.hssf.record.ExtendedFormatRecord, org.apache.poi.hssf.usermodel.HSSFWorkbook)"><!-- --></A><H3>
HSSFCellStyle</H3>
<PRE>
protected <B>HSSFCellStyle</B>(short&nbsp;index,
                        <A HREF="../../../../../org/apache/poi/hssf/record/ExtendedFormatRecord.html" title="class in org.apache.poi.hssf.record">ExtendedFormatRecord</A>&nbsp;rec,
                        <A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</A>&nbsp;workbook)</PRE>
<DL>
<DD>Creates new HSSFCellStyle why would you want to do this??
<P>
</DL>
<HR>

<A NAME="HSSFCellStyle(short, org.apache.poi.hssf.record.ExtendedFormatRecord, org.apache.poi.hssf.model.InternalWorkbook)"><!-- --></A><H3>
HSSFCellStyle</H3>
<PRE>
protected <B>HSSFCellStyle</B>(short&nbsp;index,
                        <A HREF="../../../../../org/apache/poi/hssf/record/ExtendedFormatRecord.html" title="class in org.apache.poi.hssf.record">ExtendedFormatRecord</A>&nbsp;rec,
                        <A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html" title="class in org.apache.poi.hssf.model">InternalWorkbook</A>&nbsp;workbook)</PRE>
<DL>
</DL>

<!-- ============ METHOD DETAIL ========== -->

<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>Method Detail</B></FONT></TH>
</TR>
</TABLE>

<A NAME="getIndex()"><!-- --></A><H3>
getIndex</H3>
<PRE>
public short <B>getIndex</B>()</PRE>
<DL>
<DD>get the index within the HSSFWorkbook (sequence within the collection of ExtnededFormat objects)
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getIndex()">getIndex</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>unique index number of the underlying record this style represents (probably you don't care
  unless you're comparing which one is which)</DL>
</DD>
</DL>
<HR>

<A NAME="getParentStyle()"><!-- --></A><H3>
getParentStyle</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html" title="class in org.apache.poi.hssf.usermodel">HSSFCellStyle</A> <B>getParentStyle</B>()</PRE>
<DL>
<DD>Return the parent style for this cell style.
 In most cases this will be null, but in a few
  cases there'll be a fully defined parent.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="setDataFormat(short)"><!-- --></A><H3>
setDataFormat</H3>
<PRE>
public void <B>setDataFormat</B>(short&nbsp;fmt)</PRE>
<DL>
<DD>set the data format (must be a valid format)
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setDataFormat(short)">setDataFormat</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFDataFormat.html" title="class in org.apache.poi.hssf.usermodel"><CODE>HSSFDataFormat</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getDataFormat()"><!-- --></A><H3>
getDataFormat</H3>
<PRE>
public short <B>getDataFormat</B>()</PRE>
<DL>
<DD>get the index of the format
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getDataFormat()">getDataFormat</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFDataFormat.html" title="class in org.apache.poi.hssf.usermodel"><CODE>HSSFDataFormat</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getDataFormatString()"><!-- --></A><H3>
getDataFormatString</H3>
<PRE>
public java.lang.String <B>getDataFormatString</B>()</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getDataFormatString()">CellStyle</A></CODE></B></DD>
<DD>Get the format string
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getDataFormatString()">getDataFormatString</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getDataFormatString(org.apache.poi.ss.usermodel.Workbook)"><!-- --></A><H3>
getDataFormatString</H3>
<PRE>
public java.lang.String <B>getDataFormatString</B>(<A HREF="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</A>&nbsp;workbook)</PRE>
<DL>
<DD>Get the contents of the format string, by looking up
  the DataFormat against the supplied workbook
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>the format string or "General" if not found<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFDataFormat.html" title="class in org.apache.poi.hssf.usermodel"><CODE>HSSFDataFormat</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getDataFormatString(org.apache.poi.hssf.model.InternalWorkbook)"><!-- --></A><H3>
getDataFormatString</H3>
<PRE>
public java.lang.String <B>getDataFormatString</B>(<A HREF="../../../../../org/apache/poi/hssf/model/InternalWorkbook.html" title="class in org.apache.poi.hssf.model">InternalWorkbook</A>&nbsp;workbook)</PRE>
<DL>
<DD>Get the contents of the format string, by looking up
  the DataFormat against the supplied low level workbook
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFDataFormat.html" title="class in org.apache.poi.hssf.usermodel"><CODE>HSSFDataFormat</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setFont(org.apache.poi.ss.usermodel.Font)"><!-- --></A><H3>
setFont</H3>
<PRE>
public void <B>setFont</B>(<A HREF="../../../../../org/apache/poi/ss/usermodel/Font.html" title="interface in org.apache.poi.ss.usermodel">Font</A>&nbsp;font)</PRE>
<DL>
<DD>set the font for this style
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFont(org.apache.poi.ss.usermodel.Font)">setFont</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>font</CODE> - a font object created or retreived from the HSSFWorkbook object<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#createFont()"><CODE>HSSFWorkbook.createFont()</CODE></A>, 
<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#getFontAt(short)"><CODE>HSSFWorkbook.getFontAt(short)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setFont(org.apache.poi.hssf.usermodel.HSSFFont)"><!-- --></A><H3>
setFont</H3>
<PRE>
public void <B>setFont</B>(<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFFont.html" title="class in org.apache.poi.hssf.usermodel">HSSFFont</A>&nbsp;font)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getFontIndex()"><!-- --></A><H3>
getFontIndex</H3>
<PRE>
public short <B>getFontIndex</B>()</PRE>
<DL>
<DD>gets the index of the font for this style
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFontIndex()">getFontIndex</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#getFontAt(short)"><CODE>HSSFWorkbook.getFontAt(short)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getFont(org.apache.poi.ss.usermodel.Workbook)"><!-- --></A><H3>
getFont</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFFont.html" title="class in org.apache.poi.hssf.usermodel">HSSFFont</A> <B>getFont</B>(<A HREF="../../../../../org/apache/poi/ss/usermodel/Workbook.html" title="interface in org.apache.poi.ss.usermodel">Workbook</A>&nbsp;parentWorkbook)</PRE>
<DL>
<DD>gets the font for this style
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parentWorkbook</CODE> - The HSSFWorkbook that this style belongs to<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getFontIndex()"><CODE>getFontIndex()</CODE></A>, 
<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html#getFontAt(short)"><CODE>HSSFWorkbook.getFontAt(short)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setHidden(boolean)"><!-- --></A><H3>
setHidden</H3>
<PRE>
public void <B>setHidden</B>(boolean&nbsp;hidden)</PRE>
<DL>
<DD>set the cell's using this style to be hidden
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setHidden(boolean)">setHidden</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>hidden</CODE> - - whether the cell using this style should be hidden</DL>
</DD>
</DL>
<HR>

<A NAME="getHidden()"><!-- --></A><H3>
getHidden</H3>
<PRE>
public boolean <B>getHidden</B>()</PRE>
<DL>
<DD>get whether the cell's using this style are to be hidden
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getHidden()">getHidden</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>hidden - whether the cell using this style should be hidden</DL>
</DD>
</DL>
<HR>

<A NAME="setLocked(boolean)"><!-- --></A><H3>
setLocked</H3>
<PRE>
public void <B>setLocked</B>(boolean&nbsp;locked)</PRE>
<DL>
<DD>set the cell's using this style to be locked
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setLocked(boolean)">setLocked</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>locked</CODE> - - whether the cell using this style should be locked</DL>
</DD>
</DL>
<HR>

<A NAME="getLocked()"><!-- --></A><H3>
getLocked</H3>
<PRE>
public boolean <B>getLocked</B>()</PRE>
<DL>
<DD>get whether the cell's using this style are to be locked
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getLocked()">getLocked</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>hidden - whether the cell using this style should be locked</DL>
</DD>
</DL>
<HR>

<A NAME="setAlignment(short)"><!-- --></A><H3>
setAlignment</H3>
<PRE>
public void <B>setAlignment</B>(short&nbsp;align)</PRE>
<DL>
<DD>set the type of horizontal alignment for the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setAlignment(short)">setAlignment</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>align</CODE> - - the type of alignment<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_GENERAL"><CODE>CellStyle.ALIGN_GENERAL</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_LEFT"><CODE>CellStyle.ALIGN_LEFT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER"><CODE>CellStyle.ALIGN_CENTER</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_RIGHT"><CODE>CellStyle.ALIGN_RIGHT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_FILL"><CODE>CellStyle.ALIGN_FILL</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_JUSTIFY"><CODE>CellStyle.ALIGN_JUSTIFY</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER_SELECTION"><CODE>CellStyle.ALIGN_CENTER_SELECTION</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getAlignment()"><!-- --></A><H3>
getAlignment</H3>
<PRE>
public short <B>getAlignment</B>()</PRE>
<DL>
<DD>get the type of horizontal alignment for the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getAlignment()">getAlignment</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>align - the type of alignment<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_GENERAL"><CODE>CellStyle.ALIGN_GENERAL</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_LEFT"><CODE>CellStyle.ALIGN_LEFT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER"><CODE>CellStyle.ALIGN_CENTER</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_RIGHT"><CODE>CellStyle.ALIGN_RIGHT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_FILL"><CODE>CellStyle.ALIGN_FILL</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_JUSTIFY"><CODE>CellStyle.ALIGN_JUSTIFY</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER_SELECTION"><CODE>CellStyle.ALIGN_CENTER_SELECTION</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setWrapText(boolean)"><!-- --></A><H3>
setWrapText</H3>
<PRE>
public void <B>setWrapText</B>(boolean&nbsp;wrapped)</PRE>
<DL>
<DD>set whether the text should be wrapped
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setWrapText(boolean)">setWrapText</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>wrapped</CODE> - wrap text or not</DL>
</DD>
</DL>
<HR>

<A NAME="getWrapText()"><!-- --></A><H3>
getWrapText</H3>
<PRE>
public boolean <B>getWrapText</B>()</PRE>
<DL>
<DD>get whether the text should be wrapped
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getWrapText()">getWrapText</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>wrap text or not</DL>
</DD>
</DL>
<HR>

<A NAME="setVerticalAlignment(short)"><!-- --></A><H3>
setVerticalAlignment</H3>
<PRE>
public void <B>setVerticalAlignment</B>(short&nbsp;align)</PRE>
<DL>
<DD>set the type of vertical alignment for the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setVerticalAlignment(short)">setVerticalAlignment</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>align</CODE> - the type of alignment<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_TOP"><CODE>CellStyle.VERTICAL_TOP</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_CENTER"><CODE>CellStyle.VERTICAL_CENTER</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_BOTTOM"><CODE>CellStyle.VERTICAL_BOTTOM</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_JUSTIFY"><CODE>CellStyle.VERTICAL_JUSTIFY</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getVerticalAlignment()"><!-- --></A><H3>
getVerticalAlignment</H3>
<PRE>
public short <B>getVerticalAlignment</B>()</PRE>
<DL>
<DD>get the type of vertical alignment for the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getVerticalAlignment()">getVerticalAlignment</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>align the type of alignment<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_TOP"><CODE>CellStyle.VERTICAL_TOP</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_CENTER"><CODE>CellStyle.VERTICAL_CENTER</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_BOTTOM"><CODE>CellStyle.VERTICAL_BOTTOM</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_JUSTIFY"><CODE>CellStyle.VERTICAL_JUSTIFY</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setRotation(short)"><!-- --></A><H3>
setRotation</H3>
<PRE>
public void <B>setRotation</B>(short&nbsp;rotation)</PRE>
<DL>
<DD>set the degree of rotation for the text in the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setRotation(short)">setRotation</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>rotation</CODE> - degrees (between -90 and 90 degrees, of 0xff for vertical)</DL>
</DD>
</DL>
<HR>

<A NAME="getRotation()"><!-- --></A><H3>
getRotation</H3>
<PRE>
public short <B>getRotation</B>()</PRE>
<DL>
<DD>get the degree of rotation for the text in the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getRotation()">getRotation</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>rotation degrees (between -90 and 90 degrees, or 0xff for vertical)</DL>
</DD>
</DL>
<HR>

<A NAME="setIndention(short)"><!-- --></A><H3>
setIndention</H3>
<PRE>
public void <B>setIndention</B>(short&nbsp;indent)</PRE>
<DL>
<DD>set the number of spaces to indent the text in the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setIndention(short)">setIndention</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>indent</CODE> - - number of spaces</DL>
</DD>
</DL>
<HR>

<A NAME="getIndention()"><!-- --></A><H3>
getIndention</H3>
<PRE>
public short <B>getIndention</B>()</PRE>
<DL>
<DD>get the number of spaces to indent the text in the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getIndention()">getIndention</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>indent - number of spaces</DL>
</DD>
</DL>
<HR>

<A NAME="setBorderLeft(short)"><!-- --></A><H3>
setBorderLeft</H3>
<PRE>
public void <B>setBorderLeft</B>(short&nbsp;border)</PRE>
<DL>
<DD>set the type of border to use for the left border of the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderLeft(short)">setBorderLeft</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>border</CODE> - type<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><CODE>CellStyle.BORDER_NONE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><CODE>CellStyle.BORDER_THIN</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><CODE>CellStyle.BORDER_MEDIUM</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><CODE>CellStyle.BORDER_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><CODE>CellStyle.BORDER_DOTTED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><CODE>CellStyle.BORDER_THICK</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><CODE>CellStyle.BORDER_DOUBLE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><CODE>CellStyle.BORDER_HAIR</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><CODE>CellStyle.BORDER_MEDIUM_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><CODE>CellStyle.BORDER_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><CODE>CellStyle.BORDER_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><CODE>CellStyle.BORDER_SLANTED_DASH_DOT</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getBorderLeft()"><!-- --></A><H3>
getBorderLeft</H3>
<PRE>
public short <B>getBorderLeft</B>()</PRE>
<DL>
<DD>get the type of border to use for the left border of the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBorderLeft()">getBorderLeft</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>border type<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><CODE>CellStyle.BORDER_NONE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><CODE>CellStyle.BORDER_THIN</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><CODE>CellStyle.BORDER_MEDIUM</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><CODE>CellStyle.BORDER_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><CODE>CellStyle.BORDER_DOTTED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><CODE>CellStyle.BORDER_THICK</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><CODE>CellStyle.BORDER_DOUBLE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><CODE>CellStyle.BORDER_HAIR</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><CODE>CellStyle.BORDER_MEDIUM_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><CODE>CellStyle.BORDER_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><CODE>CellStyle.BORDER_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><CODE>CellStyle.BORDER_SLANTED_DASH_DOT</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setBorderRight(short)"><!-- --></A><H3>
setBorderRight</H3>
<PRE>
public void <B>setBorderRight</B>(short&nbsp;border)</PRE>
<DL>
<DD>set the type of border to use for the right border of the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderRight(short)">setBorderRight</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>border</CODE> - type<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><CODE>CellStyle.BORDER_NONE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><CODE>CellStyle.BORDER_THIN</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><CODE>CellStyle.BORDER_MEDIUM</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><CODE>CellStyle.BORDER_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><CODE>CellStyle.BORDER_DOTTED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><CODE>CellStyle.BORDER_THICK</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><CODE>CellStyle.BORDER_DOUBLE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><CODE>CellStyle.BORDER_HAIR</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><CODE>CellStyle.BORDER_MEDIUM_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><CODE>CellStyle.BORDER_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><CODE>CellStyle.BORDER_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><CODE>CellStyle.BORDER_SLANTED_DASH_DOT</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getBorderRight()"><!-- --></A><H3>
getBorderRight</H3>
<PRE>
public short <B>getBorderRight</B>()</PRE>
<DL>
<DD>get the type of border to use for the right border of the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBorderRight()">getBorderRight</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>border type<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><CODE>CellStyle.BORDER_NONE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><CODE>CellStyle.BORDER_THIN</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><CODE>CellStyle.BORDER_MEDIUM</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><CODE>CellStyle.BORDER_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><CODE>CellStyle.BORDER_DOTTED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><CODE>CellStyle.BORDER_THICK</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><CODE>CellStyle.BORDER_DOUBLE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><CODE>CellStyle.BORDER_HAIR</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><CODE>CellStyle.BORDER_MEDIUM_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><CODE>CellStyle.BORDER_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><CODE>CellStyle.BORDER_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><CODE>CellStyle.BORDER_SLANTED_DASH_DOT</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setBorderTop(short)"><!-- --></A><H3>
setBorderTop</H3>
<PRE>
public void <B>setBorderTop</B>(short&nbsp;border)</PRE>
<DL>
<DD>set the type of border to use for the top border of the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderTop(short)">setBorderTop</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>border</CODE> - type<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><CODE>CellStyle.BORDER_NONE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><CODE>CellStyle.BORDER_THIN</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><CODE>CellStyle.BORDER_MEDIUM</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><CODE>CellStyle.BORDER_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><CODE>CellStyle.BORDER_DOTTED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><CODE>CellStyle.BORDER_THICK</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><CODE>CellStyle.BORDER_DOUBLE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><CODE>CellStyle.BORDER_HAIR</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><CODE>CellStyle.BORDER_MEDIUM_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><CODE>CellStyle.BORDER_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><CODE>CellStyle.BORDER_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><CODE>CellStyle.BORDER_SLANTED_DASH_DOT</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getBorderTop()"><!-- --></A><H3>
getBorderTop</H3>
<PRE>
public short <B>getBorderTop</B>()</PRE>
<DL>
<DD>get the type of border to use for the top border of the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBorderTop()">getBorderTop</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>border type<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><CODE>CellStyle.BORDER_NONE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><CODE>CellStyle.BORDER_THIN</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><CODE>CellStyle.BORDER_MEDIUM</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><CODE>CellStyle.BORDER_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><CODE>CellStyle.BORDER_DOTTED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><CODE>CellStyle.BORDER_THICK</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><CODE>CellStyle.BORDER_DOUBLE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><CODE>CellStyle.BORDER_HAIR</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><CODE>CellStyle.BORDER_MEDIUM_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><CODE>CellStyle.BORDER_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><CODE>CellStyle.BORDER_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><CODE>CellStyle.BORDER_SLANTED_DASH_DOT</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setBorderBottom(short)"><!-- --></A><H3>
setBorderBottom</H3>
<PRE>
public void <B>setBorderBottom</B>(short&nbsp;border)</PRE>
<DL>
<DD>set the type of border to use for the bottom border of the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderBottom(short)">setBorderBottom</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>border</CODE> - type<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><CODE>CellStyle.BORDER_NONE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><CODE>CellStyle.BORDER_THIN</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><CODE>CellStyle.BORDER_MEDIUM</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><CODE>CellStyle.BORDER_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><CODE>CellStyle.BORDER_DOTTED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><CODE>CellStyle.BORDER_THICK</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><CODE>CellStyle.BORDER_DOUBLE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><CODE>CellStyle.BORDER_HAIR</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><CODE>CellStyle.BORDER_MEDIUM_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><CODE>CellStyle.BORDER_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><CODE>CellStyle.BORDER_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><CODE>CellStyle.BORDER_SLANTED_DASH_DOT</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getBorderBottom()"><!-- --></A><H3>
getBorderBottom</H3>
<PRE>
public short <B>getBorderBottom</B>()</PRE>
<DL>
<DD>get the type of border to use for the bottom border of the cell
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBorderBottom()">getBorderBottom</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>border type<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><CODE>CellStyle.BORDER_NONE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><CODE>CellStyle.BORDER_THIN</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><CODE>CellStyle.BORDER_MEDIUM</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><CODE>CellStyle.BORDER_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><CODE>CellStyle.BORDER_DOTTED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><CODE>CellStyle.BORDER_THICK</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><CODE>CellStyle.BORDER_DOUBLE</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><CODE>CellStyle.BORDER_HAIR</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><CODE>CellStyle.BORDER_MEDIUM_DASHED</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><CODE>CellStyle.BORDER_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><CODE>CellStyle.BORDER_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><CODE>CellStyle.BORDER_MEDIUM_DASH_DOT_DOT</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><CODE>CellStyle.BORDER_SLANTED_DASH_DOT</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setLeftBorderColor(short)"><!-- --></A><H3>
setLeftBorderColor</H3>
<PRE>
public void <B>setLeftBorderColor</B>(short&nbsp;color)</PRE>
<DL>
<DD>set the color to use for the left border
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setLeftBorderColor(short)">setLeftBorderColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>color</CODE> - The index of the color definition</DL>
</DD>
</DL>
<HR>

<A NAME="getLeftBorderColor()"><!-- --></A><H3>
getLeftBorderColor</H3>
<PRE>
public short <B>getLeftBorderColor</B>()</PRE>
<DL>
<DD>get the color to use for the left border
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getLeftBorderColor()">getLeftBorderColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>The index of the color definition<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFPalette.html#getColor(short)"><CODE>HSSFPalette.getColor(short)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setRightBorderColor(short)"><!-- --></A><H3>
setRightBorderColor</H3>
<PRE>
public void <B>setRightBorderColor</B>(short&nbsp;color)</PRE>
<DL>
<DD>set the color to use for the right border
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setRightBorderColor(short)">setRightBorderColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>color</CODE> - The index of the color definition</DL>
</DD>
</DL>
<HR>

<A NAME="getRightBorderColor()"><!-- --></A><H3>
getRightBorderColor</H3>
<PRE>
public short <B>getRightBorderColor</B>()</PRE>
<DL>
<DD>get the color to use for the left border
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getRightBorderColor()">getRightBorderColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>The index of the color definition<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFPalette.html#getColor(short)"><CODE>HSSFPalette.getColor(short)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setTopBorderColor(short)"><!-- --></A><H3>
setTopBorderColor</H3>
<PRE>
public void <B>setTopBorderColor</B>(short&nbsp;color)</PRE>
<DL>
<DD>set the color to use for the top border
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setTopBorderColor(short)">setTopBorderColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>color</CODE> - The index of the color definition</DL>
</DD>
</DL>
<HR>

<A NAME="getTopBorderColor()"><!-- --></A><H3>
getTopBorderColor</H3>
<PRE>
public short <B>getTopBorderColor</B>()</PRE>
<DL>
<DD>get the color to use for the top border
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getTopBorderColor()">getTopBorderColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>The index of the color definition<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFPalette.html#getColor(short)"><CODE>HSSFPalette.getColor(short)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setBottomBorderColor(short)"><!-- --></A><H3>
setBottomBorderColor</H3>
<PRE>
public void <B>setBottomBorderColor</B>(short&nbsp;color)</PRE>
<DL>
<DD>set the color to use for the bottom border
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBottomBorderColor(short)">setBottomBorderColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>color</CODE> - The index of the color definition</DL>
</DD>
</DL>
<HR>

<A NAME="getBottomBorderColor()"><!-- --></A><H3>
getBottomBorderColor</H3>
<PRE>
public short <B>getBottomBorderColor</B>()</PRE>
<DL>
<DD>get the color to use for the left border
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBottomBorderColor()">getBottomBorderColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>The index of the color definition<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFPalette.html#getColor(short)"><CODE>HSSFPalette.getColor(short)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setFillPattern(short)"><!-- --></A><H3>
setFillPattern</H3>
<PRE>
public void <B>setFillPattern</B>(short&nbsp;fp)</PRE>
<DL>
<DD>setting to one fills the cell with the foreground color... No idea about
 other values
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillPattern(short)">setFillPattern</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>fp</CODE> - fill pattern (set to 1 to fill w/foreground color)<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#NO_FILL"><CODE>CellStyle.NO_FILL</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SOLID_FOREGROUND"><CODE>CellStyle.SOLID_FOREGROUND</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#FINE_DOTS"><CODE>CellStyle.FINE_DOTS</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALT_BARS"><CODE>CellStyle.ALT_BARS</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SPARSE_DOTS"><CODE>CellStyle.SPARSE_DOTS</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_HORZ_BANDS"><CODE>CellStyle.THICK_HORZ_BANDS</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_VERT_BANDS"><CODE>CellStyle.THICK_VERT_BANDS</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_BACKWARD_DIAG"><CODE>CellStyle.THICK_BACKWARD_DIAG</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_FORWARD_DIAG"><CODE>CellStyle.THICK_FORWARD_DIAG</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BIG_SPOTS"><CODE>CellStyle.BIG_SPOTS</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BRICKS"><CODE>CellStyle.BRICKS</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_HORZ_BANDS"><CODE>CellStyle.THIN_HORZ_BANDS</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_VERT_BANDS"><CODE>CellStyle.THIN_VERT_BANDS</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_BACKWARD_DIAG"><CODE>CellStyle.THIN_BACKWARD_DIAG</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_FORWARD_DIAG"><CODE>CellStyle.THIN_FORWARD_DIAG</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SQUARES"><CODE>CellStyle.SQUARES</CODE></A>, 
<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#DIAMONDS"><CODE>CellStyle.DIAMONDS</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getFillPattern()"><!-- --></A><H3>
getFillPattern</H3>
<PRE>
public short <B>getFillPattern</B>()</PRE>
<DL>
<DD>get the fill pattern (??) - set to 1 to fill with foreground color
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillPattern()">getFillPattern</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>fill pattern</DL>
</DD>
</DL>
<HR>

<A NAME="setFillBackgroundColor(short)"><!-- --></A><H3>
setFillBackgroundColor</H3>
<PRE>
public void <B>setFillBackgroundColor</B>(short&nbsp;bg)</PRE>
<DL>
<DD>set the background fill color.
 <p>
 For example:
 <pre>
 cs.setFillPattern(HSSFCellStyle.FINE_DOTS );
 cs.setFillBackgroundColor(new HSSFColor.RED().getIndex());
 </pre>
 optionally a Foreground and background fill can be applied:
 <i>Note: Ensure Foreground color is set prior to background</i>
 <pre>
 cs.setFillPattern(HSSFCellStyle.FINE_DOTS );
 cs.setFillForegroundColor(new HSSFColor.BLUE().getIndex());
 cs.setFillBackgroundColor(new HSSFColor.RED().getIndex());
 </pre>
 or, for the special case of SOLID_FILL:
 <pre>
 cs.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND );
 cs.setFillForegroundColor(new HSSFColor.RED().getIndex());
 </pre>
 It is necessary to set the fill style in order
 for the color to be shown in the cell.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillBackgroundColor(short)">setFillBackgroundColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>bg</CODE> - color</DL>
</DD>
</DL>
<HR>

<A NAME="getFillBackgroundColor()"><!-- --></A><H3>
getFillBackgroundColor</H3>
<PRE>
public short <B>getFillBackgroundColor</B>()</PRE>
<DL>
<DD>Get the background fill color.
 Note - many cells are actually filled with a foreground
  fill, not a background fill - see <A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getFillForegroundColor()"><CODE>getFillForegroundColor()</CODE></A>
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillBackgroundColor()">getFillBackgroundColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>fill color<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFPalette.html#getColor(short)"><CODE>HSSFPalette.getColor(short)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getFillBackgroundColorColor()"><!-- --></A><H3>
getFillBackgroundColorColor</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/util/HSSFColor.html" title="class in org.apache.poi.hssf.util">HSSFColor</A> <B>getFillBackgroundColorColor</B>()</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillBackgroundColorColor()">CellStyle</A></CODE></B></DD>
<DD>Gets the color object representing the current
  background fill, resolving indexes using
  the supplied workbook.
 This will work for both indexed and rgb
  defined colors.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillBackgroundColorColor()">getFillBackgroundColorColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="setFillForegroundColor(short)"><!-- --></A><H3>
setFillForegroundColor</H3>
<PRE>
public void <B>setFillForegroundColor</B>(short&nbsp;bg)</PRE>
<DL>
<DD>set the foreground fill color
 <i>Note: Ensure Foreground color is set prior to background color.</i>
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillForegroundColor(short)">setFillForegroundColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>bg</CODE> - color</DL>
</DD>
</DL>
<HR>

<A NAME="getFillForegroundColor()"><!-- --></A><H3>
getFillForegroundColor</H3>
<PRE>
public short <B>getFillForegroundColor</B>()</PRE>
<DL>
<DD>Get the foreground fill color.
 Many cells are filled with this, instead of a
  background color (<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html#getFillBackgroundColor()"><CODE>getFillBackgroundColor()</CODE></A>)
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillForegroundColor()">getFillForegroundColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>fill color<DT><B>See Also:</B><DD><A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFPalette.html#getColor(short)"><CODE>HSSFPalette.getColor(short)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getFillForegroundColorColor()"><!-- --></A><H3>
getFillForegroundColorColor</H3>
<PRE>
public <A HREF="../../../../../org/apache/poi/hssf/util/HSSFColor.html" title="class in org.apache.poi.hssf.util">HSSFColor</A> <B>getFillForegroundColorColor</B>()</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillForegroundColorColor()">CellStyle</A></CODE></B></DD>
<DD>Gets the color object representing the current
  foreground fill, resolving indexes using
  the supplied workbook.
 This will work for both indexed and rgb
  defined colors.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillForegroundColorColor()">getFillForegroundColorColor</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getUserStyleName()"><!-- --></A><H3>
getUserStyleName</H3>
<PRE>
public java.lang.String <B>getUserStyleName</B>()</PRE>
<DL>
<DD>Gets the name of the user defined style.
 Returns null for built in styles, and
  styles where no name has been defined
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="setUserStyleName(java.lang.String)"><!-- --></A><H3>
setUserStyleName</H3>
<PRE>
public void <B>setUserStyleName</B>(java.lang.String&nbsp;styleName)</PRE>
<DL>
<DD>Sets the name of the user defined style.
 Will complain if you try this on a built in style.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="setShrinkToFit(boolean)"><!-- --></A><H3>
setShrinkToFit</H3>
<PRE>
public void <B>setShrinkToFit</B>(boolean&nbsp;shrinkToFit)</PRE>
<DL>
<DD>Controls if the Cell should be auto-sized
  to shrink to fit if the text is too long
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setShrinkToFit(boolean)">setShrinkToFit</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getShrinkToFit()"><!-- --></A><H3>
getShrinkToFit</H3>
<PRE>
public boolean <B>getShrinkToFit</B>()</PRE>
<DL>
<DD>Should the Cell be auto-sized by Excel to shrink
  it to fit if this text is too long?
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getShrinkToFit()">getShrinkToFit</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="verifyBelongsToWorkbook(org.apache.poi.hssf.usermodel.HSSFWorkbook)"><!-- --></A><H3>
verifyBelongsToWorkbook</H3>
<PRE>
public void <B>verifyBelongsToWorkbook</B>(<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFWorkbook.html" title="class in org.apache.poi.hssf.usermodel">HSSFWorkbook</A>&nbsp;wb)</PRE>
<DL>
<DD>Verifies that this style belongs to the supplied Workbook.
 Will throw an exception if it belongs to a different one.
 This is normally called when trying to assign a style to a
  cell, to ensure the cell and the style are from the same
  workbook (if they're not, it won't work)
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>

<DT><B>Throws:</B>
<DD><CODE>java.lang.IllegalArgumentException</CODE> - if there's a workbook mis-match</DL>
</DD>
</DL>
<HR>

<A NAME="cloneStyleFrom(org.apache.poi.ss.usermodel.CellStyle)"><!-- --></A><H3>
cloneStyleFrom</H3>
<PRE>
public void <B>cloneStyleFrom</B>(<A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A>&nbsp;source)</PRE>
<DL>
<DD>Clones all the style information from another
  HSSFCellStyle, onto this one. This
  HSSFCellStyle will then have all the same
  properties as the source, but the two may
  be edited independently.
 Any stylings on this HSSFCellStyle will be lost!

 The source HSSFCellStyle could be from another
  HSSFWorkbook if you like. This allows you to
  copy styles from one HSSFWorkbook to another.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#cloneStyleFrom(org.apache.poi.ss.usermodel.CellStyle)">cloneStyleFrom</A></CODE> in interface <CODE><A HREF="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="cloneStyleFrom(org.apache.poi.hssf.usermodel.HSSFCellStyle)"><!-- --></A><H3>
cloneStyleFrom</H3>
<PRE>
public void <B>cloneStyleFrom</B>(<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html" title="class in org.apache.poi.hssf.usermodel">HSSFCellStyle</A>&nbsp;source)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="hashCode()"><!-- --></A><H3>
hashCode</H3>
<PRE>
public int <B>hashCode</B>()</PRE>
<DL>
<DD><DL>
<DT><B>Overrides:</B><DD><CODE>hashCode</CODE> in class <CODE>java.lang.Object</CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="equals(java.lang.Object)"><!-- --></A><H3>
equals</H3>
<PRE>
public boolean <B>equals</B>(java.lang.Object&nbsp;obj)</PRE>
<DL>
<DD><DL>
<DT><B>Overrides:</B><DD><CODE>equals</CODE> in class <CODE>java.lang.Object</CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<!-- ========= END OF CLASS DATA ========= -->
<HR>


<!-- ======= START OF BOTTOM NAVBAR ====== -->
<A NAME="navbar_bottom"><!-- --></A>
<A HREF="#skip-navbar_bottom" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_bottom_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
  <TR ALIGN="center" VALIGN="top">
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="class-use/HSSFCellStyle.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFCell.html" title="class in org.apache.poi.hssf.usermodel"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../../../../org/apache/poi/hssf/usermodel/HSSFChart.html" title="class in org.apache.poi.hssf.usermodel"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../../index.html?org/apache/poi/hssf/usermodel/HSSFCellStyle.html" target="_top"><B>FRAMES</B></A>  &nbsp;
&nbsp;<A HREF="HSSFCellStyle.html" target="_top"><B>NO FRAMES</B></A>  &nbsp;
&nbsp;<SCRIPT type="text/javascript">
  <!--
  if(window==top) {
    document.writeln('<A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>');
  }
  //-->
</SCRIPT>
<NOSCRIPT>
  <A HREF="../../../../../allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>


</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
  SUMMARY:&nbsp;NESTED&nbsp;|&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_summary">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL:&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_detail">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_bottom"></A>
<!-- ======== END OF BOTTOM NAVBAR ======= -->

<HR>

                <i>Copyright 2014 The Apache Software Foundation or
        its licensors, as applicable.</i>
            
</BODY>
</HTML>
